// 银行转账明细
const {DataTypes, db } = require("../db");
db.define('invoiceTrans', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
iid:{type: DataTypes.INTEGER,comment:'自身关联单据ID'}, 
transType:{type: DataTypes.INTEGER,comment:''}, 
billState:{type: DataTypes.STRING(50),comment:''}, 
billNo:{type: DataTypes.STRING(100),comment:'票号'}, 
accId:{type: DataTypes.INTEGER,allowNull:false,comment:'转出账户ID'}, 
accName:{type: DataTypes.STRING(50),allowNull:false,comment:'转出账户名称'}, 
amount:{type: DataTypes.DECIMAL(20, 2),allowNull:false,comment:'转账金额'}, 
remark:{type: DataTypes.STRING(255),comment:'备注'}, 
accId1:{type: DataTypes.INTEGER,comment:'转入账户'}, 
accName1:{type: DataTypes.STRING(255),comment:'转入账户'}, 
oldId:{type: DataTypes.INTEGER,comment:''}, 

}, {
    tableName: 'invoice_trans',
    timestamps: false,
    comment: '银行转账明细',
    
});